Use this database to keep track of your frequent flyer miles.
How to use this solution
Enter your frequent flyer transactions into the form. You can keep track of miles you receive from flying or from credit card transactions, hotel stays, and so on. You can also keep track of the miles you redeem, by entering a debit transaction.
When you need to know how many frequent flyer miles you have earned, you can use the Mileage Summary report.
How to customize this solution
You caB
n track frequent flyer miles for more than one person by adding a name field. You can link this name field to another database using relations. For instance, you might want to keep track of miles for employees or travel agency customers.
A Form View
A List View
Mileage Summary
Information
Total Bonus MilesB
Transaction TypeB
Credit
Miles CalcB
_ = "Credit"
Credit
Total Miles CalcB
InfoB
A Form ViewB
Report Menu
A List ViewB
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Total Mileage:
Bonus Miles:
Air Miles:
Transaction Type
Description
|#Enter data for Frequent Flyer Miles
Air Mileage
Transaction
Mileage SummaryB
Total[
Bonus\
Type^
From`
Descriptiona
Dateb
Your Own
Buttonc
Your Own
Buttond
Recorde
Delete
Recordf
Recordg
Reportsh
View As
Listi
View As
Formj
Closek
Infol*Click to see more information for a record
InformationB
Your Own
Button
Reports
View As
View As
Close
Balance:
Page ##
Mileage Summary
Bonus
Total
Description
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO-Information about the Frequent Flyer solutionP
Info for this Solution
about the Frequent Flyer solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Mileage SummaryE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
06/09/95Y
09/12/95
AA 538
4/8/95
Credit
06/09/95Y
01/13/96
AA 2022
4/8/95
Credit
06/09/95Y
06/09/95
AV 7 DY Buffalo APO NY
4/8/95
Credit
06/09/95Y
06/09/95
AA 1861
4/14/95
Credit
06/09/95Y
06/09/95
AA 1467
4/14/95
Credit
06/09/95Y
06/09/95
QQ 580
4/20/95
Credit
06/09/95Y
06/09/95
AV 1 DY John Wayne APO CA
4/20/95
Credit
06/09/95Y
06/09/95
AV 1 DY Oregon-Portland AP
4/20/95
Credit
06/09/95Y
06/09/95
AV 4 DY Phoenix APO AZ
4/24/95
Credit
06/09/95Y
06/09/95
AV 1 DY Ontario APO CA
5/1/95
Credit
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
debit
credit
credit
buffalo
wayne
oregon-portland
phoenix
ontario
purchases
purchases
debit
Sort by Date
Sort by Description
Sort by Transaction Type
Sort for Mileage Summary
Mileage Summary
Open Script
Sort by Date
Sort by Description
06/09/95Y
01/13/96
Bank Card Purchases
4/4/95
Credit
06/09/95Y
09/13/95
Bank Card Purchases
5/4/95
Credit
06/09/95Y
09/12/95
AA 538
4/8/95
Debit
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
CWF_Mono
Mileage Summary
Sort by Transaction Type
Sort for Mileage Summary
Open Script
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA
Debit
Credit
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
Transaction Type ListB
Travel From ListC
Travel To List
wwwwww
ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
*00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUU
UUUUUU
wwwwww
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
(.txt)